<div id="content">
	<div id="hotelTableWrapper">
		<?php
		$con = mysql_connect("localhost","root","");
		if (!$con) {
		  die('Could not connect: ' . mysql_error());
		  }
		
		mysql_select_db("travelcompany", $con);
		
		$result = mysql_query("SELECT * 
		FROM hotel h
		INNER JOIN chain c ON h.chainID = c.chainID
		INNER JOIN address a ON h.addressID = a.addressID
		INNER JOIN country co ON a.countryID = co.countryID
		");
		
		echo "<table id='hotelTable' class='tableStyle'>
		<tr>
		<th>Hotelname</th>
		<th>Hotelkettenname</th>
		<th>Addresse</th>
		<th>Land</th>
		</tr>";
		
		while($row = mysql_fetch_array($result))
		  {
		  echo "<tr>";
		  echo "<td>" . $row[1] . "</td>";
		  echo "<td>" . $row[7] . "</td>";
		  echo "<td>" . $row[10] . "</td>";
		  echo "<td>" . $row[13] . "</td>";
		  echo "</tr>";
		  }
		echo "</table>";
		
		?>
	</div>
	<div id="clientTableWrapper">
		<?php
		
		$result = mysql_query("SELECT * 
		FROM client c
		INNER JOIN address a ON c.addressID = a.addressID
		INNER JOIN country co ON a.countryID = co.countryID
		INNER JOIN client_advisor ca ON c.client_advisorID = ca.client_advisorID; 
		");
		
		echo "<table id='clientTable' class='tableStyle'>
		<tr>
		<th>Vorname</th>
		<th>Nachname</th>
		<th>Addresse</th>
		<th>Land</th>
		<th>Kundenberater</th>
		</tr>";
		
		while($row = mysql_fetch_array($result))
		  {
		  echo "<tr>";
		  echo "<td>" . $row[3] . "</td>";
		  echo "<td>" . $row[4] . "</td>";
		  echo "<td>" . $row[5] . "</td>";
		  echo "<td>" . $row[8] . "</td>";
		  echo "<td>" . $row[11] . "</td>";
		  echo "</tr>";
		  }
		echo "</table>";
		
		mysql_close($con);
		?>
</div>